193afa6fbe0c57358f9f0aae61bb5a0952714d9c,tests/frontend/org/voltdb/planner/TestPlansGroupBy.java,TestPlansGroupBy,testMultiPartitionMVBasedQuery_NoAggQuery,#,236
Before Change
pns = compileToFragments("SELECT * FROM V_P1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3); // 5 (# of select) - 2 (# of group-by)
pns = compileToFragments("SELECT * FROM V_P1 order by V_A1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);
pns = compileToFragments("SELECT * FROM V_P1 order by V_A1, V_B1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);
pns = compileToFragments("SELECT * FROM V_P1 order by V_SUM_D1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);
pns = compileToFragments("SELECT * FROM V_P1 limit 1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);
pns = compileToFragments("SELECT * FROM V_P1 order by V_A1, V_B1 limit 1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);
pns = compileToFragments("SELECT v_sum_c1 FROM V_P1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 1);
pns = compileToFragments("SELECT v_sum_c1 FROM V_P1 order by v_sum_c1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 1);
After Change
// FROM P1 GROUP BY A1, B1;
String[] tbs = {"V_P1", "V_P1_ABS"};
for (String tb: tbs) {
pns = compileToFragments("SELECT * FROM " + tb);
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3); // 5 (# of select) - 2 (# of group-by)
pns = compileToFragments("SELECT * FROM " + tb + " order by V_A1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);
pns = compileToFragments("SELECT * FROM " + tb + " order by V_A1, V_B1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);
pns = compileToFragments("SELECT * FROM " + tb + " order by V_SUM_D1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);
pns = compileToFragments("SELECT * FROM " + tb + " limit 1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);
pns = compileToFragments("SELECT * FROM " + tb + " order by V_A1, V_B1 limit 1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);
pns = compileToFragments("SELECT v_sum_c1 FROM " + tb + "");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 1);
pns = compileToFragments("SELECT v_sum_c1 FROM " + tb + " order by v_sum_c1");
checkMVReaggreateFeatureNoBottomAgg(pns, 2, 1);